﻿IF EXISTS (SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME = 'puestoUpdate')
	BEGIN
		DROP  Procedure  puestoUpdate
	END
GO

CREATE PROCEDURE [dbo].[puestoUpdate] 	
	(	
		@id AS INT,
		@empresa_id AS INT,
		@nombre AS VARCHAR(50)
	)	
AS
BEGIN	
	SET NOCOUNT ON
	  
	UPDATE	Lit_Puesto
	SET		EmpresaId = @empresa_id,
			Nombre = @nombre	
	WHERE id = @id
	
	SET NOCOUNT OFF
END

GO 